﻿using System;
namespace BZZ.Model
{
	/// <summary>
	/// 博客内容实体类：blog 。
	/// </summary>
	[Serializable]
	public class blog
	{
		public blog()
		{}

		#region Model
		private int _id; //id
		private int _cataid; //一级分类
		private int _subcataid; //二级分类
		private string _tag; //标签
		private string _title; //标题
		private string _content; //内容
		private string _comment; //点评
		private int _hits; //点击数
		private int _commentCount; //评论数
		private int _sourceId; //采集源id
		private string _sourceUrl; //来源网址
		private DateTime? _pubDate; //发布时间
		private int _status; //状态
		private string _ext1; //扩展1
		private string _ext2; //扩展2


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 一级分类
		/// </summary>
		public int cataid
		{
			set{ _cataid=value;}
			get{return _cataid;}
		}
        /// <summary>
		/// 二级分类
		/// </summary>
		public int subcataid
		{
			set{ _subcataid=value;}
			get{return _subcataid;}
		}
        /// <summary>
		/// 标签
		/// </summary>
		public string tag
		{
			set{ _tag=value;}
			get{return _tag;}
		}
        /// <summary>
		/// 标题
		/// </summary>
		public string title
		{
			set{ _title=value;}
			get{return _title;}
		}
        /// <summary>
		/// 内容
		/// </summary>
		public string content
		{
			set{ _content=value;}
			get{return _content;}
		}
        /// <summary>
		/// 点评
		/// </summary>
		public string comment
		{
			set{ _comment=value;}
			get{return _comment;}
		}
        /// <summary>
		/// 点击数
		/// </summary>
		public int hits
		{
			set{ _hits=value;}
			get{return _hits;}
		}
        /// <summary>
		/// 评论数
		/// </summary>
		public int commentCount
		{
			set{ _commentCount=value;}
			get{return _commentCount;}
		}
        /// <summary>
		/// 采集源id
		/// </summary>
		public int sourceId
		{
			set{ _sourceId=value;}
			get{return _sourceId;}
		}
        /// <summary>
		/// 来源网址
		/// </summary>
		public string sourceUrl
		{
			set{ _sourceUrl=value;}
			get{return _sourceUrl;}
		}
        /// <summary>
		/// 发布时间
		/// </summary>
		public DateTime? pubDate
		{
			set{ _pubDate=value;}
			get{return _pubDate;}
		}
        /// <summary>
		/// 状态
		/// </summary>
		public int status
		{
			set{ _status=value;}
			get{return _status;}
		}
        /// <summary>
		/// 扩展1
		/// </summary>
		public string ext1
		{
			set{ _ext1=value;}
			get{return _ext1;}
		}
        /// <summary>
		/// 扩展2
		/// </summary>
		public string ext2
		{
			set{ _ext2=value;}
			get{return _ext2;}
		}
		#endregion Model

		#region txt document
		/*
博客内容,blog
id,一级分类,二级分类,标签,标题,内容,点评,点击数,评论数,采集源id,来源网址,发布时间,状态,扩展1,扩展2
id,cataid,subcataid,tag,title,content,comment,hits,commentCount,sourceId,sourceUrl,pubDate,status,ext1,ext2
i,i,i,c256,c256,t,c1000,i,i,i,c256,d,i,c100,c100

--------------------------
-- 创建表[博客内容]开始: 
-- alter table  [BZZ_blog] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='BZZ_blog') drop table BZZ_blog
  CREATE TABLE [BZZ_blog] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [cataid] int,
	 [subcataid] int,
	 [tag] [varchar] (256),
	 [title] [varchar] (256),
	 [content] [text],
	 [comment] [varchar] (1000),
	 [hits] int,
	 [commentCount] int,
	 [sourceId] int,
	 [sourceUrl] [varchar] (256),
	 [pubDate] [datetime],
	 [status] int,
	 [ext1] [varchar] (100),
	 [ext2] [varchar] (100)
  )

 exec sp_addextendedproperty N'MS_Description',N'博客内容 ',N'user',N'dbo',N'table',N'BZZ_blog', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'BZZ_blog',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'一级分类',N'user',N'dbo',N'table',N'BZZ_blog',N'column',N'cataid'
 exec sp_addextendedproperty N'MS_Description',N'二级分类',N'user',N'dbo',N'table',N'BZZ_blog',N'column',N'subcataid'
 exec sp_addextendedproperty N'MS_Description',N'标签',N'user',N'dbo',N'table',N'BZZ_blog',N'column',N'tag'
 exec sp_addextendedproperty N'MS_Description',N'标题',N'user',N'dbo',N'table',N'BZZ_blog',N'column',N'title'
 exec sp_addextendedproperty N'MS_Description',N'内容',N'user',N'dbo',N'table',N'BZZ_blog',N'column',N'content'
 exec sp_addextendedproperty N'MS_Description',N'点评',N'user',N'dbo',N'table',N'BZZ_blog',N'column',N'comment'
 exec sp_addextendedproperty N'MS_Description',N'点击数',N'user',N'dbo',N'table',N'BZZ_blog',N'column',N'hits'
 exec sp_addextendedproperty N'MS_Description',N'评论数',N'user',N'dbo',N'table',N'BZZ_blog',N'column',N'commentCount'
 exec sp_addextendedproperty N'MS_Description',N'采集源id',N'user',N'dbo',N'table',N'BZZ_blog',N'column',N'sourceId'
 exec sp_addextendedproperty N'MS_Description',N'来源网址',N'user',N'dbo',N'table',N'BZZ_blog',N'column',N'sourceUrl'
 exec sp_addextendedproperty N'MS_Description',N'发布时间',N'user',N'dbo',N'table',N'BZZ_blog',N'column',N'pubDate'
 exec sp_addextendedproperty N'MS_Description',N'状态',N'user',N'dbo',N'table',N'BZZ_blog',N'column',N'status'
 exec sp_addextendedproperty N'MS_Description',N'扩展1',N'user',N'dbo',N'table',N'BZZ_blog',N'column',N'ext1'
 exec sp_addextendedproperty N'MS_Description',N'扩展2',N'user',N'dbo',N'table',N'BZZ_blog',N'column',N'ext2'

-- 创建表[博客内容]结束。 
--------------------------

		*/
		#endregion document
	}
}

